xp-dev.com Git - namibia/blob - data/old_b4c stuff/publictemplate.sql

   1 -- MySQL dump 10.13  Distrib 5.6.13, for Win32 (x86)
   2 --
   3 -- Host: 127.0.0.1    Database: mig_db
   4 -- ------------------------------------------------------
   5 -- Server version       5.5.36
   6
   7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10 /*!40101 SET NAMES utf8 */;
  11 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  14 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  15
  16 LOCK TABLES `lib_template` WRITE;
  17 /*!40000 ALTER TABLE `lib_template` DISABLE KEYS */;
  18 INSERT INTO `lib_template` (`lib_repeater_template_id`, `name`, `subject`, `tags`, `email_template`, `sms_template`) VALUES (NULL,'public-submission','Notification of successful submission of vehicle.','first_name,family_name,year,make,model,type,reg_no','<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n     \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n <head>\r\n      <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r\n   <title></title>\r\n </head>\r\n <body style=\"padding:0;margin:0;\">\r\n        <!-- Begin 100% Wrapping Table -->\r\n  <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r\n               <tr>\r\n                        <td style=\"padding:20px 0;\">\r\n                              <!-- Begin Main Template Table -->\r\n                          <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r\n                                    <tr>\r\n                                                <td>\r\n                                                <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r\n                                          </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style=\"background:#f6f6f6;padding:20px 0\">\r\n                                                    <!-- Main Content table -->\r\n                                                         <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n                                                              <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r\n                                                                   <!-- Main Column -->\r\n                                                                        <td width=\"420\" valign=\"top\" style=\"width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n                                                                            <h1 style=\"font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;\">\r\n                                                                                   Notification of successfull submission of vehicle\r\n                                                                           </h1>\r\n                                                                               <p style=\"margin:0 0 1em;padding:0;\">\r\n                                                                                     &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style=\"margin:0 0 1em;padding:0;\">\r\n                                                                                     Dear [first_name] [family_name],\r\n                                                                            </p>\r\n                                                                                <p style=\"margin:0 0 1em;padding:0;\">\r\n                                                                                     We would like to confirm that the following vehicle was successfully\r\n                                                                                        submitted to the Bid4Cars Dealer to Dealer online portal for valuation:\r\n                                                                             </p>\r\n                                                            <p style=\"margin:0 0 1em;padding:0;\">\r\n                                                        <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420px\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n                                                          <tr>\r\n                                                                  <td width=\"80px\"><b>Year:</b></td>\r\n                                                                <td><b>[year]</b></td>\r\n                                                            </tr>\r\n                                                               <tr>\r\n                                                                  <td width=\"80px\"><b>Make:</b></td>\r\n                                                                <td><b>[make]</b></td>\r\n                                                            </tr>\r\n                                                               <tr>\r\n                                                                  <td width=\"80px\"><b>Model:</b></td>\r\n                                                               <td><b>[model]</b></td>\r\n                                                           </tr>\r\n                                                               <tr>\r\n                                                                  <td width=\"80px\"><b>Type:</b></td>\r\n                                                                <td><b>[type]</b></td>\r\n                                                            </tr>\r\n                                                               <tr>\r\n                                                                  <td width=\"80px\"><b>Reg no:</b></td>\r\n                                                              <td><b>[reg_no]</b></td>\r\n                                                          </tr>\r\n                                                             </table>\r\n                                                              </p>\r\n                                                                                <p style=\"margin:0 0 1em;padding:0;\">\r\n                                                           &nbsp;\r\n                                                            </p>\r\n                                                        <p style=\"margin:0 0 1em;padding:0;\"><br/>\r\n                                                          Kind Regards,<br/>\r\n                                                          The Bid4Cars Team\r\n                                                         </p>\r\n                                                                   </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width=\"40\" valign=\"top\" style=\"width:40px;\">&nbsp;</td>\r\n                                                                   <!-- Side Column -->\r\n                                                                        <td width=\"300\" valign=\"top\" style=\"width:300px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n                                                                            <img src=\"{APP_HOST}/images/hammer.gif\" width=\"300px\" alt=\"Content Image\" align=\"left\" style=\"padding:5px;\" />\r\n                                                                            <h2 style=\"font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;\">Auctions</h2>\r\n                                                                           <p style=\"margin:0 0 1em;padding:5px;\">\r\n                                                                                   Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style=\"background:#ececec;padding:10px 0 0;\">\r\n                                                         <!-- Begin Footer table -->\r\n                                                         <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"600\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n                                                              <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r\n                                                                   <!-- Main Column -->\r\n                                                                        <td width=\"560\" valign=\"top\" style=\"width:560px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n                                                                            <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.com.na</b></p>\r\n                                                                   </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;&nbsp;</td>\r\n                                                             </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n <!-- /End 100% Wrapping Table  -->\r\n </body>\r\n </html>\r\n','');
  19 /*!40000 ALTER TABLE `lib_template` ENABLE KEYS */;
  20 UNLOCK TABLES;
  21
  22 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  23 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  24 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  25 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  26 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  27 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  28 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  29
  30 -- Dump completed